import pandas as pd

# 定义表头信息
columns = [
    "doctor_code", "doctor_name", "outpatient_visits", "avg_fee_per_visit",
    "avg_drug_fee_per_visit", "avg_inspection_fee_per_visit", "avg_treatment_fee_per_visit",
    "antibiotic_prescription_rate", "prescription_tcm", "prescription_western",
    "inspection_items", "treatment_fee_total", "treatment_fee_nco", "treatment_fee_medicare",
    "treatment_fee_public", "treatment_fee_self", "diagnostic_fee_total", "diagnostic_fee_nco",
    "diagnostic_fee_medicare", "diagnostic_fee_public", "diagnostic_fee_self",
    "laboratory_fee_total", "laboratory_fee_nco", "laboratory_fee_medicare",
    "laboratory_fee_public", "laboratory_fee_self", "material_fee_total", "material_fee_nco",
    "material_fee_medicare", "material_fee_public", "material_fee_self",
    "western_medicine_fee_total", "western_medicine_fee_nco", "western_medicine_fee_medicare",
    "western_medicine_fee_public", "western_medicine_fee_self", "inspection_fee_total",
    "inspection_fee_nco", "inspection_fee_medicare", "inspection_fee_public",
    "inspection_fee_self", "tcm_fee_total", "tcm_fee_nco", "tcm_fee_medicare",
    "tcm_fee_public", "tcm_fee_self", "nursing_fee_total", "nursing_fee_nco",
    "nursing_fee_medicare", "nursing_fee_public", "nursing_fee_self",
    "special_material_fee_total", "special_material_fee_nco", "special_material_fee_medicare",
    "special_material_fee_public", "special_material_fee_self", "surgery_fee_total",
    "surgery_fee_nco", "surgery_fee_medicare", "surgery_fee_public", "surgery_fee_self",
    "other_fee_total", "other_fee_nco", "other_fee_medicare", "other_fee_public",
    "other_fee_self", "bed_fee_total", "bed_fee_nco", "bed_fee_medicare", "bed_fee_public",
    "bed_fee_self", "radiation_fee_total", "radiation_fee_nco", "radiation_fee_medicare",
    "radiation_fee_public", "radiation_fee_self", "registration_fee_total",
    "registration_fee_nco", "registration_fee_medicare", "registration_fee_public",
    "registration_fee_self", "herbal_fee_total", "herbal_fee_nco", "herbal_fee_medicare",
    "herbal_fee_public", "herbal_fee_self", "temperature_regulation_fee_total",
    "temperature_regulation_fee_nco", "temperature_regulation_fee_medicare",
    "temperature_regulation_fee_public", "temperature_regulation_fee_self", "total_sum",
    "total_sum_nco", "total_sum_medicare", "total_sum_public", "total_sum_self"
]

# 创建空的DataFrame
df = pd.DataFrame(columns=columns)



# 保存到Excel文件
with pd.ExcelWriter("doctors_data.xlsx", engine="openpyxl") as writer:
    df.to_excel(writer, index=False)

print("Excel file created successfully.")